// var CateDescSQL={
//     selectDrink:"select dr_cate_id,sj_num from drink_person_sj where stu_id=? order by sj_sort",
//     selectTrain:"select tra_cate_id,sj_num from train_person_sj where stu_id=? order by sj_sort",
//     selectSleep:"select sle_cate_id,sj_num from sleep_person_sj where stu_id=? order by sj_sort",
//     selectSelfStudy:"select ss_cate_id ,sj_num from selfstu_person_sj where stu_id=? order by sj_sort",
//     selectMood:"select mood_cate_id,sj_num from mood_person_sj where stu_id=? order by sj_sort"
//   };
var CateDescSQL={
       selectDrink:"select dr_cate_id,sj_num from drink_person_sj where dr_cate_id=? and stu_id=? order by sj_sort",
        updateDrink:"update drink_person_sj set sj_num=sj_num+? where dr_cate_id=? and stu_id=?",
        insertDrink:"insert into drink_person_sj(sj_num,dr_cate_id,stu_id,sj_sort) values(?,?,?,?)",
    
        selectTrain:"select tra_cate_id,sj_num from sports_person_sj where tra_cate_id=? and stu_id=?  order by sj_sort",
        updateTrain:"update sports_person_sj set sj_num=sj_num+? where tra_cate_id=? and stu_id=?",
        insertTrain:"insert into sports_person_sj(sj_num,tra_cate_id,stu_id,sj_sort) values(?,?,?,?)",
        
        selectCateName:"select cate_name from catetest where cate_id=?",

        selectDrinkData:"select dr_cate_id,sj_num from drink_person_sj where stu_id=? and dr_cate_id=? order by sj_sort",
        selectDrinkDesc:"select drink_radio_desc from drink_ratio_healthy where dr_cate_id=? and ?-drink_ratio_num>0 order by drink_ratio_id desc limit 1",
        
        selectTrainData:"select tra_cate_id,sj_num from sports_person_sj where stu_id=? and tra_cate_id=? order by sj_sort",
        selectTrainDesc:"select sp_radio_desc from sports_ratio_healthy where sp_cate_id=? and ?-sp_ratio_num>0 order by sports_ratio_id desc limit 1"
        
    };
  module.exports=CateDescSQL;